Overview
Brought to you by YData
Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 1628258 |
| Missing cells | 103746 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 352.7 MiB |
| Average record size in memory | 227.2 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 4 |
| Text | 1 |
eval_set has constant value "prior" | Constant |
aisle has a high cardinality: 134 distinct values | High cardinality |
department is highly overall correlated with department_id | High correlation |
department_id is highly overall correlated with department | High correlation |
days_since_prior_order has 103746 (6.4%) missing values | Missing |
order_dow has 309011 (19.0%) zeros | Zeros |
days_since_prior_order has 21367 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-10-12 18:18:59.028778 |
|---|---|
| Analysis finished | 2025-10-12 18:20:15.914954 |
| Duration | 1 minute and 16.89 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
order_id
Real number (ℝ)
| Distinct | 161752 |
|---|---|
| Distinct (%) | 9.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1711654.8 |
| Minimum | 28 |
|---|---|
| Maximum | 3421083 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 28 |
|---|---|
| 5-th percentile | 167144 |
| Q1 | 861420 |
| median | 1711303 |
| Q3 | 2570465 |
| 95-th percentile | 3249603 |
| Maximum | 3421083 |
| Range | 3421055 |
| Interquartile range (IQR) | 1709045 |
Descriptive statistics
| Standard deviation | 987490.76 |
|---|---|
| Coefficient of variation (CV) | 0.57692168 |
| Kurtosis | -1.1994225 |
| Mean | 1711654.8 |
| Median Absolute Deviation (MAD) | 854109 |
| Skewness | -0.0036100055 |
| Sum | 2.7870156 × 1012 |
| Variance | 9.75138 × 1011 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 3065077 | 86 | < 0.1% |
| 2621428 | 76 | < 0.1% |
| 521291 | 72 | < 0.1% |
| 2640800 | 71 | < 0.1% |
| 2877090 | 70 | < 0.1% |
| 1477139 | 68 | < 0.1% |
| 1723549 | 67 | < 0.1% |
| 1007609 | 64 | < 0.1% |
| 3205600 | 63 | < 0.1% |
| 3097933 | 63 | < 0.1% |
| Other values (161742) | 1627558 |
| Value | Count | Frequency (%) |
| 28 | 16 | |
| 48 | 8 | < 0.1% |
| 54 | 7 | < 0.1% |
| 67 | 8 | < 0.1% |
| 71 | 10 | |
| 109 | 21 | |
| 122 | 2 | < 0.1% |
| 138 | 6 | < 0.1% |
| 151 | 4 | < 0.1% |
| 156 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 3421083 | 10 | |
| 3421080 | 9 | |
| 3421066 | 6 | < 0.1% |
| 3420988 | 8 | |
| 3420968 | 10 | |
| 3420938 | 12 | |
| 3420918 | 15 | |
| 3420908 | 6 | < 0.1% |
| 3420901 | 12 | |
| 3420897 | 10 |
product_id
Real number (ℝ)
| Distinct | 35600 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25645.597 |
| Minimum | 1 |
|---|---|
| Maximum | 49688 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3399 |
| Q1 | 13598 |
| median | 25464 |
| Q3 | 38100 |
| 95-th percentile | 47601 |
| Maximum | 49688 |
| Range | 49687 |
| Interquartile range (IQR) | 24502 |
Descriptive statistics
| Standard deviation | 14092.605 |
|---|---|
| Coefficient of variation (CV) | 0.54951364 |
| Kurtosis | -1.140182 |
| Mean | 25645.597 |
| Median Absolute Deviation (MAD) | 12215 |
| Skewness | -0.026094877 |
| Sum | 4.1757649 × 1010 |
| Variance | 1.9860153 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24852 | 23082 | 1.4% |
| 13176 | 19056 | 1.2% |
| 21137 | 13445 | 0.8% |
| 21903 | 12152 | 0.7% |
| 47209 | 10874 | 0.7% |
| 47766 | 9073 | 0.6% |
| 47626 | 7616 | 0.5% |
| 26209 | 7349 | 0.5% |
| 27845 | 7197 | 0.4% |
| 16797 | 7075 | 0.4% |
| Other values (35590) | 1511339 |
| Value | Count | Frequency (%) |
| 1 | 71 | |
| 2 | 2 | < 0.1% |
| 3 | 6 | < 0.1% |
| 4 | 13 | < 0.1% |
| 5 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 8 | < 0.1% |
| 10 | 134 | |
| 11 | 8 | < 0.1% |
| 12 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 49688 | 2 | < 0.1% |
| 49686 | 2 | < 0.1% |
| 49685 | 6 | < 0.1% |
| 49683 | 5192 | |
| 49682 | 1 | < 0.1% |
| 49680 | 62 | < 0.1% |
| 49679 | 5 | < 0.1% |
| 49678 | 10 | < 0.1% |
| 49677 | 9 | < 0.1% |
| 49676 | 4 | < 0.1% |
add_to_cart_order
Real number (ℝ)
| Distinct | 86 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2750479 |
| Minimum | 1 |
|---|---|
| Maximum | 86 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 11 |
| 95-th percentile | 22 |
| Maximum | 86 |
| Range | 85 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 6.9281293 |
|---|---|
| Coefficient of variation (CV) | 0.83723131 |
| Kurtosis | 3.6996824 |
| Mean | 8.2750479 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.6209974 |
| Sum | 13473913 |
| Variance | 47.998975 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 161752 | 9.9% |
| 2 | 153881 | 9.5% |
| 3 | 144405 | 8.9% |
| 4 | 133991 | 8.2% |
| 5 | 123003 | 7.6% |
| 6 | 111455 | 6.8% |
| 7 | 99893 | 6.1% |
| 8 | 88888 | 5.5% |
| 9 | 78593 | 4.8% |
| 10 | 69340 | 4.3% |
| Other values (76) | 463057 |
| Value | Count | Frequency (%) |
| 1 | 161752 | |
| 2 | 153881 | |
| 3 | 144405 | |
| 4 | 133991 | |
| 5 | 123003 | |
| 6 | 111455 | |
| 7 | 99893 | |
| 8 | 88888 | |
| 9 | 78593 | |
| 10 | 69340 |
| Value | Count | Frequency (%) |
| 86 | 1 | |
| 85 | 1 | |
| 84 | 1 | |
| 83 | 1 | |
| 82 | 1 | |
| 81 | 1 | |
| 80 | 1 | |
| 79 | 1 | |
| 78 | 1 | |
| 77 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 958236 | |
| 0 | 670022 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 958236 | |
| 0 | 670022 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 958236 | |
| 0 | 670022 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1628258 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 958236 | |
| 0 | 670022 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1628258 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 958236 | |
| 0 | 670022 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1628258 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 958236 | |
| 0 | 670022 |
product_name
Text
| Distinct | 35600 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 127.6 MiB |
Length
| Max length | 159 |
|---|---|
| Median length | 120 |
| Mean length | 24.95476 |
| Min length | 3 |
Unique
| Unique | 6761 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | Salted Butter |
|---|---|
| 2nd row | Cream Cheese |
| 3rd row | Air Chilled Organic Boneless Skinless Chicken Breasts |
| 4th row | Organic D'Anjou Pears |
| 5th row | Cultured Low Fat Buttermilk |
| Value | Count | Frequency (%) |
| organic | 518491 | 8.4% |
| 100020 | 1.6% | |
| milk | 86989 | 1.4% |
| cheese | 71582 | 1.2% |
| yogurt | 66273 | 1.1% |
| whole | 62735 | 1.0% |
| free | 58486 | 0.9% |
| water | 50567 | 0.8% |
| baby | 49910 | 0.8% |
| original | 48536 | 0.8% |
| Other values (9606) | 5070524 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4564521 | 11.2% | |
| e | 3814750 | 9.4% |
| a | 3465999 | 8.5% |
| r | 2868253 | 7.1% |
| i | 2403362 | 5.9% |
| n | 2229947 | 5.5% |
| o | 1783377 | 4.4% |
| l | 1679957 | 4.1% |
| t | 1670456 | 4.1% |
| s | 1355246 | 3.3% |
| Other values (95) | 14796919 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 29544165 | |
| Uppercase Letter | 5997347 | 14.8% |
| Space Separator | 4564798 | 11.2% |
| Other Punctuation | 266245 | 0.7% |
| Decimal Number | 190364 | 0.5% |
| Dash Punctuation | 47240 | 0.1% |
| Close Punctuation | 7826 | < 0.1% |
| Open Punctuation | 7826 | < 0.1% |
| Math Symbol | 3720 | < 0.1% |
| Other Symbol | 3194 | < 0.1% |
| Other values (4) | 62 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3814750 | |
| a | 3465999 | |
| r | 2868253 | |
| i | 2403362 | 8.1% |
| n | 2229947 | 7.5% |
| o | 1783377 | 6.0% |
| l | 1679957 | 5.7% |
| t | 1670456 | 5.7% |
| s | 1355246 | 4.6% |
| c | 1318540 | 4.5% |
| Other values (26) | 6954278 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 731615 | |
| O | 684910 | |
| S | 677128 | |
| B | 615469 | 10.3% |
| P | 379916 | 6.3% |
| F | 297783 | 5.0% |
| M | 288947 | 4.8% |
| G | 282360 | 4.7% |
| A | 243320 | 4.1% |
| R | 237773 | 4.0% |
| Other values (16) | 1558126 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 93682 | |
| , | 70277 | |
| % | 63226 | |
| ' | 15156 | 5.7% |
| / | 9318 | 3.5% |
| ! | 4733 | 1.8% |
| . | 4565 | 1.7% |
| : | 1909 | 0.7% |
| \ | 1353 | 0.5% |
| " | 1353 | 0.5% |
| Other values (5) | 673 | 0.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 66384 | |
| 1 | 42352 | |
| 2 | 36411 | |
| 3 | 12944 | 6.8% |
| 4 | 7963 | 4.2% |
| 5 | 7632 | 4.0% |
| 9 | 5711 | 3.0% |
| 8 | 4173 | 2.2% |
| 7 | 3453 | 1.8% |
| 6 | 3341 | 1.8% |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 1966 | |
| ™ | 1223 | |
| � | 4 | 0.1% |
| ° | 1 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 47087 | |
| ‑ | 145 | 0.3% |
| – | 8 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 4564521 | ||
| 277 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 3505 | |
| = | 215 | 5.8% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ˚ | 4 | |
| ´ | 3 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 7826 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 7826 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 24 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 19 |
Control
| Value | Count | Frequency (%) |
| | 12 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35541444 | |
| Common | 5091275 | 12.5% |
| Cyrillic | 68 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3814750 | 10.7% |
| a | 3465999 | 9.8% |
| r | 2868253 | 8.1% |
| i | 2403362 | 6.8% |
| n | 2229947 | 6.3% |
| o | 1783377 | 5.0% |
| l | 1679957 | 4.7% |
| t | 1670456 | 4.7% |
| s | 1355246 | 3.8% |
| c | 1318540 | 3.7% |
| Other values (51) | 12951557 |
Common
| Value | Count | Frequency (%) |
| 4564521 | ||
| & | 93682 | 1.8% |
| , | 70277 | 1.4% |
| 0 | 66384 | 1.3% |
| % | 63226 | 1.2% |
| - | 47087 | 0.9% |
| 1 | 42352 | 0.8% |
| 2 | 36411 | 0.7% |
| ' | 15156 | 0.3% |
| 3 | 12944 | 0.3% |
| Other values (33) | 79235 | 1.6% |
Cyrillic
| Value | Count | Frequency (%) |
| е | 68 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40627936 | |
| None | 3380 | < 0.1% |
| Letterlike Symbols | 1223 | < 0.1% |
| Punctuation | 172 | < 0.1% |
| Cyrillic | 68 | < 0.1% |
| Modifier Letters | 4 | < 0.1% |
| Specials | 4 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4564521 | 11.2% | |
| e | 3814750 | 9.4% |
| a | 3465999 | 8.5% |
| r | 2868253 | 7.1% |
| i | 2403362 | 5.9% |
| n | 2229947 | 5.5% |
| o | 1783377 | 4.4% |
| l | 1679957 | 4.1% |
| t | 1670456 | 4.1% |
| s | 1355246 | 3.3% |
| Other values (74) | 14792068 |
None
| Value | Count | Frequency (%) |
| ® | 1966 | |
| é | 710 | 21.0% |
| 277 | 8.2% | |
| ñ | 246 | 7.3% |
| è | 92 | 2.7% |
| í | 48 | 1.4% |
| | 12 | 0.4% |
| ü | 8 | 0.2% |
| â | 6 | 0.2% |
| ô | 6 | 0.2% |
| Other values (4) | 9 | 0.3% |
Letterlike Symbols
| Value | Count | Frequency (%) |
| ™ | 1223 |
Punctuation
| Value | Count | Frequency (%) |
| ‑ | 145 | |
| ’ | 19 | 11.0% |
| – | 8 | 4.7% |
Cyrillic
| Value | Count | Frequency (%) |
| е | 68 |
Modifier Letters
| Value | Count | Frequency (%) |
| ˚ | 4 |
Specials
| Value | Count | Frequency (%) |
| � | 4 |
aisle_id
Real number (ℝ)
| Distinct | 134 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.227631 |
| Minimum | 1 |
|---|---|
| Maximum | 134 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 31 |
| median | 83 |
| Q3 | 107 |
| 95-th percentile | 123 |
| Maximum | 134 |
| Range | 133 |
| Interquartile range (IQR) | 76 |
Descriptive statistics
| Standard deviation | 38.151598 |
|---|---|
| Coefficient of variation (CV) | 0.53562918 |
| Kurtosis | -1.3250255 |
| Mean | 71.227631 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | -0.16663328 |
| Sum | 1.1597696 × 108 |
| Variance | 1455.5444 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 182972 | 11.2% |
| 83 | 173830 | 10.7% |
| 123 | 89048 | 5.5% |
| 120 | 71129 | 4.4% |
| 21 | 48244 | 3.0% |
| 84 | 44769 | 2.7% |
| 115 | 43346 | 2.7% |
| 107 | 35820 | 2.2% |
| 91 | 32037 | 2.0% |
| 112 | 29796 | 1.8% |
| Other values (124) | 877267 |
| Value | Count | Frequency (%) |
| 1 | 3331 | 0.2% |
| 2 | 4200 | 0.3% |
| 3 | 21859 | |
| 4 | 9632 | |
| 5 | 3159 | 0.2% |
| 6 | 1939 | 0.1% |
| 7 | 1640 | 0.1% |
| 8 | 1749 | 0.1% |
| 9 | 11078 | |
| 10 | 429 | < 0.1% |
| Value | Count | Frequency (%) |
| 134 | 550 | < 0.1% |
| 133 | 975 | 0.1% |
| 132 | 344 | < 0.1% |
| 131 | 13589 | |
| 130 | 7931 | |
| 129 | 9163 | |
| 128 | 9792 | |
| 127 | 1956 | 0.1% |
| 126 | 946 | 0.1% |
| 125 | 1722 | 0.1% |
department_id
Real number (ℝ)
High correlation
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.8816557 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 9 |
| Q3 | 16 |
| 95-th percentile | 19 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 6.2720808 |
|---|---|
| Coefficient of variation (CV) | 0.63471963 |
| Kurtosis | -1.556463 |
| Mean | 9.8816557 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.15978088 |
| Sum | 16089885 |
| Variance | 39.338998 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 479501 | |
| 16 | 270170 | |
| 19 | 141984 | 8.7% |
| 7 | 133421 | 8.2% |
| 1 | 112718 | 6.9% |
| 13 | 95048 | 5.8% |
| 3 | 59411 | 3.6% |
| 15 | 53922 | 3.3% |
| 20 | 52533 | 3.2% |
| 9 | 43511 | 2.7% |
| Other values (11) | 186039 | 11.4% |
| Value | Count | Frequency (%) |
| 1 | 112718 | 6.9% |
| 2 | 1939 | 0.1% |
| 3 | 59411 | 3.6% |
| 4 | 479501 | |
| 5 | 7448 | 0.5% |
| 6 | 14351 | 0.9% |
| 7 | 133421 | 8.2% |
| 8 | 5104 | 0.3% |
| 9 | 43511 | 2.7% |
| 10 | 1530 | 0.1% |
| Value | Count | Frequency (%) |
| 21 | 3435 | 0.2% |
| 20 | 52533 | 3.2% |
| 19 | 141984 | |
| 18 | 20834 | 1.3% |
| 17 | 36529 | 2.2% |
| 16 | 270170 | |
| 15 | 53922 | 3.3% |
| 14 | 36173 | 2.2% |
| 13 | 95048 | 5.8% |
| 12 | 36280 | 2.2% |
aisle
Categorical
High cardinality
| Distinct | 134 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| fresh fruits | |
|---|---|
| fresh vegetables | |
| packaged vegetables fruits | 89048 |
| yogurt | 71129 |
| packaged cheese | 48244 |
| Other values (129) |
Length
| Max length | 29 |
|---|---|
| Median length | 23 |
| Mean length | 14.451632 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | butter |
|---|---|
| 2nd row | other creams cheeses |
| 3rd row | poultry counter |
| 4th row | fresh fruits |
| 5th row | milk |
Common Values
| Value | Count | Frequency (%) |
| fresh fruits | 182972 | 11.2% |
| fresh vegetables | 173830 | 10.7% |
| packaged vegetables fruits | 89048 | 5.5% |
| yogurt | 71129 | 4.4% |
| packaged cheese | 48244 | 3.0% |
| milk | 44769 | 2.7% |
| water seltzer sparkling water | 43346 | 2.7% |
| chips pretzels | 35820 | 2.2% |
| soy lactosefree | 32037 | 2.0% |
| bread | 29796 | 1.8% |
| Other values (124) | 877267 |
Length
| Value | Count | Frequency (%) |
| fresh | 396104 | 11.4% |
| vegetables | 278597 | 8.0% |
| fruits | 272837 | 7.9% |
| packaged | 160237 | 4.6% |
| frozen | 88137 | 2.5% |
| water | 86692 | 2.5% |
| yogurt | 71129 | 2.1% |
| ice | 49715 | 1.4% |
| cheese | 48244 | 1.4% |
| milk | 44769 | 1.3% |
| Other values (194) | 1964439 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3369157 | |
| s | 2230435 | 9.5% |
| r | 1993943 | 8.5% |
| a | 1848210 | 7.9% |
| 1832642 | 7.8% | |
| t | 1383598 | 5.9% |
| f | 1014726 | 4.3% |
| i | 938425 | 4.0% |
| o | 885014 | 3.8% |
| g | 877805 | 3.7% |
| Other values (16) | 7157030 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 21698343 | |
| Space Separator | 1832642 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3369157 | |
| s | 2230435 | 10.3% |
| r | 1993943 | 9.2% |
| a | 1848210 | 8.5% |
| t | 1383598 | 6.4% |
| f | 1014726 | 4.7% |
| i | 938425 | 4.3% |
| o | 885014 | 4.1% |
| g | 877805 | 4.0% |
| c | 836378 | 3.9% |
| Other values (15) | 6320652 |
Space Separator
| Value | Count | Frequency (%) |
| 1832642 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21698343 | |
| Common | 1832642 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3369157 | |
| s | 2230435 | 10.3% |
| r | 1993943 | 9.2% |
| a | 1848210 | 8.5% |
| t | 1383598 | 6.4% |
| f | 1014726 | 4.7% |
| i | 938425 | 4.3% |
| o | 885014 | 4.1% |
| g | 877805 | 4.0% |
| c | 836378 | 3.9% |
| Other values (15) | 6320652 |
Common
| Value | Count | Frequency (%) |
| 1832642 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23530985 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3369157 | |
| s | 2230435 | 9.5% |
| r | 1993943 | 8.5% |
| a | 1848210 | 7.9% |
| 1832642 | 7.8% | |
| t | 1383598 | 5.9% |
| f | 1014726 | 4.3% |
| i | 938425 | 4.0% |
| o | 885014 | 3.8% |
| g | 877805 | 3.7% |
| Other values (16) | 7157030 |
department
Categorical
High correlation
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 14.0 MiB |
| produce | |
|---|---|
| dairy eggs | |
| snacks | |
| beverages | |
| frozen | |
| Other values (16) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 8.0017344 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | dairy eggs |
|---|---|
| 2nd row | dairy eggs |
| 3rd row | meat seafood |
| 4th row | produce |
| 5th row | dairy eggs |
Common Values
| Value | Count | Frequency (%) |
| produce | 479501 | |
| dairy eggs | 270170 | |
| snacks | 141984 | 8.7% |
| beverages | 133421 | 8.2% |
| frozen | 112718 | 6.9% |
| pantry | 95048 | 5.8% |
| bakery | 59411 | 3.6% |
| canned goods | 53922 | 3.3% |
| deli | 52533 | 3.2% |
| dry goods pasta | 43511 | 2.7% |
| Other values (11) | 186039 | 11.4% |
Length
| Value | Count | Frequency (%) |
| produce | 479501 | |
| dairy | 270170 | |
| eggs | 270170 | |
| snacks | 141984 | 6.8% |
| beverages | 133421 | 6.4% |
| frozen | 112718 | 5.4% |
| goods | 97433 | 4.6% |
| pantry | 95048 | 4.5% |
| bakery | 59411 | 2.8% |
| canned | 53922 | 2.6% |
| Other values (16) | 384290 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1660840 | |
| r | 1291075 | 9.9% |
| a | 1087700 | 8.3% |
| d | 1069879 | 8.2% |
| s | 992709 | 7.6% |
| o | 986305 | 7.6% |
| g | 774629 | 5.9% |
| c | 705271 | 5.4% |
| p | 645580 | 5.0% |
| n | 526498 | 4.0% |
| Other values (13) | 3288402 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12559078 | |
| Space Separator | 469810 | 3.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1660840 | |
| r | 1291075 | |
| a | 1087700 | 8.7% |
| d | 1069879 | 8.5% |
| s | 992709 | 7.9% |
| o | 986305 | 7.9% |
| g | 774629 | 6.2% |
| c | 705271 | 5.6% |
| p | 645580 | 5.1% |
| n | 526498 | 4.2% |
| Other values (12) | 2818592 |
Space Separator
| Value | Count | Frequency (%) |
| 469810 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12559078 | |
| Common | 469810 | 3.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1660840 | |
| r | 1291075 | |
| a | 1087700 | 8.7% |
| d | 1069879 | 8.5% |
| s | 992709 | 7.9% |
| o | 986305 | 7.9% |
| g | 774629 | 6.2% |
| c | 705271 | 5.6% |
| p | 645580 | 5.1% |
| n | 526498 | 4.2% |
| Other values (12) | 2818592 |
Common
| Value | Count | Frequency (%) |
| 469810 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13028888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1660840 | |
| r | 1291075 | 9.9% |
| a | 1087700 | 8.3% |
| d | 1069879 | 8.2% |
| s | 992709 | 7.6% |
| o | 986305 | 7.6% |
| g | 774629 | 5.9% |
| c | 705271 | 5.4% |
| p | 645580 | 5.0% |
| n | 526498 | 4.0% |
| Other values (13) | 3288402 |
user_id
Real number (ℝ)
| Distinct | 10310 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103260.41 |
| Minimum | 5 |
|---|---|
| Maximum | 206186 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 11859 |
| Q1 | 52889 |
| median | 101343 |
| Q3 | 155002 |
| 95-th percentile | 195555 |
| Maximum | 206186 |
| Range | 206181 |
| Interquartile range (IQR) | 102113 |
Descriptive statistics
| Standard deviation | 59044.277 |
|---|---|
| Coefficient of variation (CV) | 0.57179977 |
| Kurtosis | -1.1996034 |
| Mean | 103260.41 |
| Median Absolute Deviation (MAD) | 51022 |
| Skewness | 0.021337609 |
| Sum | 1.6813458 × 1011 |
| Variance | 3.4862266 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 182401 | 2907 | 0.2% |
| 147480 | 2004 | 0.1% |
| 95967 | 1992 | 0.1% |
| 132022 | 1920 | 0.1% |
| 151378 | 1886 | 0.1% |
| 171771 | 1862 | 0.1% |
| 146770 | 1809 | 0.1% |
| 29041 | 1776 | 0.1% |
| 13131 | 1600 | 0.1% |
| 53928 | 1587 | 0.1% |
| Other values (10300) | 1608915 |
| Value | Count | Frequency (%) |
| 5 | 37 | < 0.1% |
| 7 | 206 | |
| 13 | 81 | < 0.1% |
| 34 | 32 | < 0.1% |
| 71 | 437 | |
| 102 | 59 | < 0.1% |
| 106 | 41 | < 0.1% |
| 118 | 165 | < 0.1% |
| 124 | 79 | < 0.1% |
| 129 | 64 | < 0.1% |
| Value | Count | Frequency (%) |
| 206186 | 32 | < 0.1% |
| 206165 | 559 | |
| 206138 | 117 | < 0.1% |
| 206133 | 21 | < 0.1% |
| 206126 | 524 | |
| 206084 | 110 | < 0.1% |
| 206076 | 18 | < 0.1% |
| 206054 | 156 | < 0.1% |
| 206044 | 158 | < 0.1% |
| 206043 | 361 |
eval_set
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 96.3 MiB |
| prior |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | prior |
|---|---|
| 2nd row | prior |
| 3rd row | prior |
| 4th row | prior |
| 5th row | prior |
Common Values
| Value | Count | Frequency (%) |
| prior | 1628258 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| prior | 1628258 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 3256516 | |
| p | 1628258 | |
| i | 1628258 | |
| o | 1628258 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8141290 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 3256516 | |
| p | 1628258 | |
| i | 1628258 | |
| o | 1628258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8141290 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 3256516 | |
| p | 1628258 | |
| i | 1628258 | |
| o | 1628258 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8141290 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 3256516 | |
| p | 1628258 | |
| i | 1628258 | |
| o | 1628258 |
order_number
Real number (ℝ)
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.261568 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 24 |
| 95-th percentile | 55 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 17.698826 |
|---|---|
| Coefficient of variation (CV) | 1.0253313 |
| Kurtosis | 3.2365932 |
| Mean | 17.261568 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7618986 |
| Sum | 28106287 |
| Variance | 313.24844 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 103746 | 6.4% |
| 3 | 102230 | 6.3% |
| 2 | 102105 | 6.3% |
| 4 | 90874 | 5.6% |
| 5 | 81424 | 5.0% |
| 6 | 73836 | 4.5% |
| 7 | 66540 | 4.1% |
| 8 | 60463 | 3.7% |
| 9 | 55667 | 3.4% |
| 10 | 52192 | 3.2% |
| Other values (89) | 839181 |
| Value | Count | Frequency (%) |
| 1 | 103746 | |
| 2 | 102105 | |
| 3 | 102230 | |
| 4 | 90874 | |
| 5 | 81424 | |
| 6 | 73836 | |
| 7 | 66540 | |
| 8 | 60463 | |
| 9 | 55667 | |
| 10 | 52192 |
| Value | Count | Frequency (%) |
| 99 | 584 | |
| 98 | 623 | |
| 97 | 681 | |
| 96 | 794 | |
| 95 | 686 | |
| 94 | 795 | |
| 93 | 892 | |
| 92 | 849 | |
| 91 | 817 | |
| 90 | 909 |
order_dow
Real number (ℝ)
Zeros
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7427361 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 309011 |
| Zeros (%) | 19.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0874903 |
|---|---|
| Coefficient of variation (CV) | 0.76109775 |
| Kurtosis | -1.3349633 |
| Mean | 2.7427361 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.17624328 |
| Sum | 4465882 |
| Variance | 4.3576157 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 309011 | |
| 1 | 287284 | |
| 6 | 224543 | |
| 5 | 212734 | |
| 2 | 208707 | |
| 3 | 193660 | |
| 4 | 192319 |
| Value | Count | Frequency (%) |
| 0 | 309011 | |
| 1 | 287284 | |
| 2 | 208707 | |
| 3 | 193660 | |
| 4 | 192319 | |
| 5 | 212734 | |
| 6 | 224543 |
| Value | Count | Frequency (%) |
| 6 | 224543 | |
| 5 | 212734 | |
| 4 | 192319 | |
| 3 | 193660 | |
| 2 | 208707 | |
| 1 | 287284 | |
| 0 | 309011 |
order_hour_of_day
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.412536 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 11147 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 10 |
| median | 13 |
| Q3 | 16 |
| 95-th percentile | 21 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.2421835 |
|---|---|
| Coefficient of variation (CV) | 0.31628497 |
| Kurtosis | 0.0033815488 |
| Mean | 13.412536 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.041912801 |
| Sum | 21839069 |
| Variance | 17.996121 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 140977 | 8.7% |
| 10 | 140359 | 8.6% |
| 14 | 137369 | 8.4% |
| 15 | 133199 | 8.2% |
| 13 | 132740 | 8.2% |
| 12 | 132071 | 8.1% |
| 16 | 125882 | 7.7% |
| 9 | 122260 | 7.5% |
| 17 | 103512 | 6.4% |
| 8 | 84685 | 5.2% |
| Other values (14) | 375204 |
| Value | Count | Frequency (%) |
| 0 | 11147 | 0.7% |
| 1 | 5762 | 0.4% |
| 2 | 3755 | 0.2% |
| 3 | 2530 | 0.2% |
| 4 | 2362 | 0.1% |
| 5 | 4718 | 0.3% |
| 6 | 14574 | 0.9% |
| 7 | 44939 | 2.8% |
| 8 | 84685 | |
| 9 | 122260 |
| Value | Count | Frequency (%) |
| 23 | 19740 | 1.2% |
| 22 | 32215 | 2.0% |
| 21 | 39597 | 2.4% |
| 20 | 49280 | 3.0% |
| 19 | 63139 | |
| 18 | 81446 | |
| 17 | 103512 | |
| 16 | 125882 | |
| 15 | 133199 | |
| 14 | 137369 |
days_since_prior_order
Real number (ℝ)
Missing Zeros
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 103746 |
| Missing (%) | 6.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.077978 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 21367 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 8 |
| Q3 | 15 |
| 95-th percentile | 30 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.769521 |
|---|---|
| Coefficient of variation (CV) | 0.79161745 |
| Kurtosis | -0.058519759 |
| Mean | 11.077978 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.0561316 |
| Sum | 16888511 |
| Variance | 76.904498 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 170442 | 10.5% |
| 30 | 153514 | 9.4% |
| 6 | 125498 | 7.7% |
| 5 | 107719 | 6.6% |
| 4 | 106087 | 6.5% |
| 3 | 95801 | 5.9% |
| 8 | 95159 | 5.8% |
| 2 | 75652 | 4.6% |
| 9 | 60567 | 3.7% |
| 14 | 51153 | 3.1% |
| Other values (21) | 482920 | |
| (Missing) | 103746 | 6.4% |
| Value | Count | Frequency (%) |
| 0 | 21367 | 1.3% |
| 1 | 48220 | 3.0% |
| 2 | 75652 | |
| 3 | 95801 | |
| 4 | 106087 | |
| 5 | 107719 | |
| 6 | 125498 | |
| 7 | 170442 | |
| 8 | 95159 | |
| 9 | 60567 | 3.7% |
| Value | Count | Frequency (%) |
| 30 | 153514 | |
| 29 | 8702 | 0.5% |
| 28 | 12606 | 0.8% |
| 27 | 9750 | 0.6% |
| 26 | 8805 | 0.5% |
| 25 | 9091 | 0.6% |
| 24 | 9811 | 0.6% |
| 23 | 10895 | 0.7% |
| 22 | 15874 | 1.0% |
| 21 | 22129 | 1.4% |
Interactions
Correlations
| add_to_cart_order | aisle_id | days_since_prior_order | department | department_id | order_dow | order_hour_of_day | order_id | order_number | product_id | reordered | user_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| add_to_cart_order | 1.000 | 0.003 | 0.080 | 0.039 | 0.009 | -0.012 | -0.019 | -0.000 | -0.002 | 0.008 | 0.128 | 0.011 |
| aisle_id | 0.003 | 1.000 | 0.004 | 0.439 | 0.024 | -0.001 | -0.003 | 0.000 | 0.006 | 0.006 | 0.088 | 0.001 |
| days_since_prior_order | 0.080 | 0.004 | 1.000 | 0.019 | 0.001 | -0.041 | -0.007 | -0.003 | -0.384 | -0.002 | 0.137 | 0.016 |
| department | 0.039 | 0.439 | 0.019 | 1.000 | 1.000 | 0.024 | 0.015 | 0.003 | 0.018 | 0.075 | 0.198 | 0.018 |
| department_id | 0.009 | 0.024 | 0.001 | 1.000 | 1.000 | 0.008 | -0.010 | 0.001 | 0.002 | -0.023 | 0.159 | 0.001 |
| order_dow | -0.012 | -0.001 | -0.041 | 0.024 | 0.008 | 1.000 | 0.007 | -0.001 | 0.010 | -0.002 | 0.016 | -0.009 |
| order_hour_of_day | -0.019 | -0.003 | -0.007 | 0.015 | -0.010 | 0.007 | 1.000 | 0.001 | -0.040 | -0.000 | 0.036 | 0.007 |
| order_id | -0.000 | 0.000 | -0.003 | 0.003 | 0.001 | -0.001 | 0.001 | 1.000 | 0.002 | 0.000 | 0.003 | -0.001 |
| order_number | -0.002 | 0.006 | -0.384 | 0.018 | 0.002 | 0.010 | -0.040 | 0.002 | 1.000 | 0.003 | 0.342 | -0.012 |
| product_id | 0.008 | 0.006 | -0.002 | 0.075 | -0.023 | -0.002 | -0.000 | 0.000 | 0.003 | 1.000 | 0.040 | -0.002 |
| reordered | 0.128 | 0.088 | 0.137 | 0.198 | 0.159 | 0.016 | 0.036 | 0.003 | 0.342 | 0.040 | 1.000 | 0.017 |
| user_id | 0.011 | 0.001 | 0.016 | 0.018 | 0.001 | -0.009 | 0.007 | -0.001 | -0.012 | -0.002 | 0.017 | 1.000 |
Missing values
Sample
| order_id | product_id | add_to_cart_order | reordered | product_name | aisle_id | department_id | aisle | department | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 268 | 28 | 35108 | 1 | 0 | Salted Butter | 36 | 16 | butter | dairy eggs | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 269 | 28 | 40593 | 2 | 1 | Cream Cheese | 108 | 16 | other creams cheeses | dairy eggs | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 270 | 28 | 17461 | 3 | 0 | Air Chilled Organic Boneless Skinless Chicken Breasts | 35 | 12 | poultry counter | meat seafood | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 271 | 28 | 22825 | 4 | 1 | Organic D'Anjou Pears | 24 | 4 | fresh fruits | produce | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 272 | 28 | 25256 | 5 | 1 | Cultured Low Fat Buttermilk | 84 | 16 | milk | dairy eggs | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 273 | 28 | 47626 | 6 | 1 | Large Lemon | 24 | 4 | fresh fruits | produce | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 274 | 28 | 37220 | 7 | 1 | Organic Strawberry Fruit Spread | 88 | 13 | spreads | pantry | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 275 | 28 | 12980 | 8 | 1 | Large Greenhouse Tomato | 83 | 4 | fresh vegetables | produce | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 276 | 28 | 27548 | 9 | 1 | Original Semisoft Cheese | 21 | 16 | packaged cheese | dairy eggs | 98256 | prior | 29 | 3 | 13 | 6.0 |
| 277 | 28 | 45504 | 10 | 1 | Whole Organic Omega 3 Milk | 84 | 16 | milk | dairy eggs | 98256 | prior | 29 | 3 | 13 | 6.0 |
| order_id | product_id | add_to_cart_order | reordered | product_name | aisle_id | department_id | aisle | department | user_id | eval_set | order_number | order_dow | order_hour_of_day | days_since_prior_order | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32434479 | 3421083 | 7854 | 1 | 0 | Freeze Dried Mango Slices | 117 | 19 | nuts seeds dried fruit | snacks | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434480 | 3421083 | 45309 | 2 | 0 | Purple Carrot & blueberry Puffs | 92 | 18 | baby food formula | babies | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434481 | 3421083 | 21162 | 3 | 0 | Organic Mixed Berry Yogurt & Fruit Snack | 92 | 18 | baby food formula | babies | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434482 | 3421083 | 18176 | 4 | 1 | Organic Strawberry Yogurt & Fruit Snack | 92 | 18 | baby food formula | babies | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434483 | 3421083 | 35211 | 5 | 0 | Organic Strawberry & Mango Dried Tiny Fruits | 92 | 18 | baby food formula | babies | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434484 | 3421083 | 39678 | 6 | 1 | Free & Clear Natural Dishwasher Detergent | 74 | 17 | dish detergents | household | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434485 | 3421083 | 11352 | 7 | 0 | Organic Mini Sandwich Crackers Peanut Butter | 78 | 19 | crackers | snacks | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434486 | 3421083 | 4600 | 8 | 0 | All Natural French Toast Sticks | 52 | 1 | frozen breakfast | frozen | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434487 | 3421083 | 24852 | 9 | 1 | Banana | 24 | 4 | fresh fruits | produce | 25247 | prior | 24 | 2 | 6 | 21.0 |
| 32434488 | 3421083 | 5020 | 10 | 1 | Organic Sweet & Salty Peanut Pretzel Granola Bars | 3 | 19 | energy granola bars | snacks | 25247 | prior | 24 | 2 | 6 | 21.0 |